﻿SELECT DISTINCT REGION, P.ACCT_MGR, P.ACCT_MGR AS x, 2 AS LVL, 2 AS ORD
FROM         SCORE_ACC_PROPERTIES.PROPERTIES P
INNER JOIN MANAGERS_WITH_SALES_VIEW V ON V.ACCT_MGR=P.ACCT_MGR
GROUP BY REGION, P.ACCT_MGR
UNION
SELECT DISTINCT REGION, ' ' + REGION AS Expr1, REGION AS Expr3, 0 AS Expr4, 0 AS Expr5
FROM         SCORE_ACC_PROPERTIES.PROPERTIES AS PROPERTIES_1
ORDER BY REGION, ORD, ACCT_MGR, LVL